UC知道[在线等,急]在ASP中实现站内搜索搜索,已完成SQL语句
来源：百度知道 编辑：UC知道 时间：2024/06/19 05:24:01
<!--#include file="Connections/data.asp" -->
<%set dataset=server.CreateObject("ADODB.RecordSet")
sqlstr="select * from DOG where (D_Kitname like '%松狮%')or( D_Kitname like '%金毛%')or(D_Kitname like '%博美%')or( D_Kitname like '%萨摩%') or ( D_Kitname like '%哈士奇%')or( D_Kitname like '%约克夏%') D_Kitname='"+reequest.form("Kitname")+"'"
dataset.open strsql,dsnstr,3,1
if dataset.eof then
response.write("没有你要查找的内容")
else
response.redirect("page1.asp")
end if
%>
总是说Microsoft VBScript 运行时错误 (0x800A01A8)
缺少对象: ''
/DOG/Untitled-1.asp, 第 12 行
如何修改或者重新帮我做一个
<!--#include file="connections/data.asp" -->
<%
set rs=server.createobject("ADODB.recordset")
rs.open "select * from [DOG] where (D_Kitname like '%松狮%')or( D_Ki
<%set dataset=server.CreateObject("ADODB.RecordSet")
sqlstr="select * from DOG where (D_Kitname like '%松狮%')or( D_Kitname like '%金毛%')or(D_Kitname like '%博美%')or( D_Kitname like '%萨摩%') or ( D_Kitname like '%哈士奇%')or( D_Kitname like '%约克夏%') D_Kitname='"+reequest.form("Kitname")+"'"
dataset.open strsql,dsnstr,3,1
if dataset.eof then
response.write("没有你要查找的内容")
else
response.redirect("page1.asp")
end if
%>
总是说Microsoft VBScript 运行时错误 (0x800A01A8)
缺少对象: ''
/DOG/Untitled-1.asp, 第 12 行
如何修改或者重新帮我做一个
<!--#include file="connections/data.asp" -->
<%
set rs=server.createobject("ADODB.recordset")
rs.open "select * from [DOG] where (D_Kitname like '%松狮%')or( D_Ki
D_Kitname like '%约克夏%') D_Kitname='"+reequest.form("Kitname")+"'"
改成
D_Kitname like '%约克夏%') or D_Kitname='"+request.form("Kitname")+"'"
另外，老大。。你这么查询。。这么多or 总感觉有问题··
---------------------------------------
说了呢···
or( D_Kitname like '%约克夏%') D_Kitname='"+request.form
你这里
( D_Kitname like '%约克夏%') D_Kitname
怎么可以这么写呢
至少要一个or或者and吧
( D_Kitname like '%约克夏%') or D_Kitname
sqlstr="select * from DOG where (D_Kitname like '%松狮%')or( D_Kitname like '%金毛%')or(D_Kitname like '%博美%')or( D_Kitname like '%萨摩%') or ( D_Kitname like '%哈士奇%')or( D_Kitname like '%约克夏%') D_Kitname='"+reequest.form("Kitname")+"'"
dataset.open strsql,dsnstr,3,1
改为
sqlstr="select * from DOG where (D_Kitname like &#